Overview

Dataset statistics

Number of variables13
Number of observations14477290
Missing cells194
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 GiB
Average record size in memory104.0 B

Variable types

Categorical10
Numeric3

Warnings

remote_addr has a high cardinality: 4405186 distinct values High cardinality
time_iso8601 has a high cardinality: 6014 distinct values High cardinality
file has a high cardinality: 913388 distinct values High cardinality
uuid has a high cardinality: 14477290 distinct values High cardinality
http_referer has a high cardinality: 111821 distinct values High cardinality
http_user_agent has a high cardinality: 118100 distinct values High cardinality
http_x_forwarded_for has a high cardinality: 2071062 distinct values High cardinality
Id has a high cardinality: 68806 distinct values High cardinality
request_time is highly skewed (γ1 = 343.9438971) Skewed
uuid is uniformly distributed Uniform
uuid has unique values Unique
request_time has 4551190 (31.4%) zeros Zeros

Reproduction

Analysis started2021-05-08 15:37:48.782584
Analysis finished2021-05-08 15:52:18.251789
Duration14 minutes and 29.47 seconds
Software versionpandas-profiling v2.12.0
Download configurationconfig.yaml

Variables

remote_addr
Categorical

HIGH CARDINALITY

Distinct4405186
Distinct (%)30.4%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
f528764d624db129b32c21fbca0cb8d6
 
192260
15da00f033afe6b99c77e5d7d35a57e0
 
25577
846b1bf90397150e78844203264a7aab
 
25563
e2cc75b407e3f6d552f466ab5ef9bf63
 
25505
cb7ef43abd8148764e9941afba6c5208
 
25502
Other values (4405181)
14182883 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters463273280
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2215246 ?
Unique (%)15.3%

Sample

1st row6c455e37ea1f3f43443ecbe46bcdb4bb
2nd row64eaa6e58e5bd71d54dd7565481a2f1d
3rd row4d4c7b25b890132ee432bebab3940966
4th rowda177836163927897f26c718d1daf85f
5th rowaffef57aacffb8aa6e911659e55f54b2
ValueCountFrequency (%)
f528764d624db129b32c21fbca0cb8d6192260
 
1.3%
15da00f033afe6b99c77e5d7d35a57e025577
 
0.2%
846b1bf90397150e78844203264a7aab25563
 
0.2%
e2cc75b407e3f6d552f466ab5ef9bf6325505
 
0.2%
cb7ef43abd8148764e9941afba6c520825502
 
0.2%
730eb5d625bc1f4568f107cee21cefb425406
 
0.2%
a485314653ea027199e94f05bad5ca2b25398
 
0.2%
3c1289e8722f7573e9918cc6fcd2964f25392
 
0.2%
081bb5cc3e5f62aa405141f36040adf925390
 
0.2%
e9ab75254c76d5c0fd13aef1004a42e025369
 
0.2%
Other values (4405176)14055928
97.1%
2021-05-08T23:52:29.541977image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
f528764d624db129b32c21fbca0cb8d6192260
 
1.3%
15da00f033afe6b99c77e5d7d35a57e025577
 
0.2%
846b1bf90397150e78844203264a7aab25563
 
0.2%
e2cc75b407e3f6d552f466ab5ef9bf6325505
 
0.2%
cb7ef43abd8148764e9941afba6c520825502
 
0.2%
730eb5d625bc1f4568f107cee21cefb425406
 
0.2%
a485314653ea027199e94f05bad5ca2b25398
 
0.2%
3c1289e8722f7573e9918cc6fcd2964f25392
 
0.2%
081bb5cc3e5f62aa405141f36040adf925390
 
0.2%
e9ab75254c76d5c0fd13aef1004a42e025369
 
0.2%
Other values (4405176)14055928
97.1%

Most occurring characters

ValueCountFrequency (%)
529719796
 
6.4%
f29298988
 
6.3%
b29266953
 
6.3%
129214234
 
6.3%
829135456
 
6.3%
629132629
 
6.3%
229049423
 
6.3%
029040790
 
6.3%
428947990
 
6.2%
d28903673
 
6.2%
Other values (6)171563348
37.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number289775842
62.5%
Lowercase Letter173497438
37.5%

Most frequent character per category

ValueCountFrequency (%)
529719796
10.3%
129214234
10.1%
829135456
10.1%
629132629
10.1%
229049423
10.0%
029040790
10.0%
428947990
10.0%
928821058
9.9%
728380371
9.8%
328334095
9.8%
ValueCountFrequency (%)
f29298988
16.9%
b29266953
16.9%
d28903673
16.7%
c28723418
16.6%
e28660480
16.5%
a28643926
16.5%

Most occurring scripts

ValueCountFrequency (%)
Common289775842
62.5%
Latin173497438
37.5%

Most frequent character per script

ValueCountFrequency (%)
529719796
10.3%
129214234
10.1%
829135456
10.1%
629132629
10.1%
229049423
10.0%
029040790
10.0%
428947990
10.0%
928821058
9.9%
728380371
9.8%
328334095
9.8%
ValueCountFrequency (%)
f29298988
16.9%
b29266953
16.9%
d28903673
16.7%
c28723418
16.6%
e28660480
16.5%
a28643926
16.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII463273280
100.0%

Most frequent character per block

ValueCountFrequency (%)
529719796
 
6.4%
f29298988
 
6.3%
b29266953
 
6.3%
129214234
 
6.3%
829135456
 
6.3%
629132629
 
6.3%
229049423
 
6.3%
029040790
 
6.3%
428947990
 
6.2%
d28903673
 
6.2%
Other values (6)171563348
37.0%

time_iso8601
Categorical

HIGH CARDINALITY

Distinct6014
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
2021-04-09T21:20:34+08:00
 
3252
2021-04-09T21:20:43+08:00
 
3248
2021-04-09T21:23:13+08:00
 
3248
2021-04-09T21:21:15+08:00
 
3239
2021-04-09T21:21:53+08:00
 
3238
Other values (6009)
14461065 

Length

Max length25
Median length25
Mean length25
Min length25

Characters and Unicode

Total characters361932250
Distinct characters14
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6 ?
Unique (%)< 0.1%

Sample

1st row2021-03-22T12:20:00+08:00
2nd row2021-03-22T12:20:00+08:00
3rd row2021-03-22T12:20:00+08:00
4th row2021-03-22T12:20:00+08:00
5th row2021-03-22T12:20:00+08:00
ValueCountFrequency (%)
2021-04-09T21:20:34+08:003252
 
< 0.1%
2021-04-09T21:20:43+08:003248
 
< 0.1%
2021-04-09T21:23:13+08:003248
 
< 0.1%
2021-04-09T21:21:15+08:003239
 
< 0.1%
2021-04-09T21:21:53+08:003238
 
< 0.1%
2021-04-10T21:23:44+08:003235
 
< 0.1%
2021-04-09T21:25:14+08:003234
 
< 0.1%
2021-04-10T21:21:11+08:003228
 
< 0.1%
2021-04-10T21:27:35+08:003224
 
< 0.1%
2021-04-09T21:21:11+08:003212
 
< 0.1%
Other values (6004)14444932
99.8%
2021-05-08T23:52:29.774597image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2021-04-09t21:20:34+08:003252
 
< 0.1%
2021-04-09t21:20:43+08:003248
 
< 0.1%
2021-04-09t21:23:13+08:003248
 
< 0.1%
2021-04-09t21:21:15+08:003239
 
< 0.1%
2021-04-09t21:21:53+08:003238
 
< 0.1%
2021-04-10t21:23:44+08:003235
 
< 0.1%
2021-04-09t21:25:14+08:003234
 
< 0.1%
2021-04-10t21:21:11+08:003228
 
< 0.1%
2021-04-10t21:27:35+08:003224
 
< 0.1%
2021-04-09t21:22:49+08:003212
 
< 0.1%
Other values (6004)14444932
99.8%

Most occurring characters

ValueCountFrequency (%)
091716826
25.3%
263490200
17.5%
:43431870
12.0%
134228870
 
9.5%
-28954580
 
8.0%
418498614
 
5.1%
817366875
 
4.8%
T14477290
 
4.0%
+14477290
 
4.0%
311026962
 
3.0%
Other values (4)24262873
 
6.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number260591220
72.0%
Other Punctuation43431870
 
12.0%
Dash Punctuation28954580
 
8.0%
Uppercase Letter14477290
 
4.0%
Math Symbol14477290
 
4.0%

Most frequent character per category

ValueCountFrequency (%)
091716826
35.2%
263490200
24.4%
134228870
 
13.1%
418498614
 
7.1%
817366875
 
6.7%
311026962
 
4.2%
98851196
 
3.4%
57046531
 
2.7%
74635876
 
1.8%
63729270
 
1.4%
ValueCountFrequency (%)
-28954580
100.0%
ValueCountFrequency (%)
T14477290
100.0%
ValueCountFrequency (%)
:43431870
100.0%
ValueCountFrequency (%)
+14477290
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common347454960
96.0%
Latin14477290
 
4.0%

Most frequent character per script

ValueCountFrequency (%)
091716826
26.4%
263490200
18.3%
:43431870
12.5%
134228870
 
9.9%
-28954580
 
8.3%
418498614
 
5.3%
817366875
 
5.0%
+14477290
 
4.2%
311026962
 
3.2%
98851196
 
2.5%
Other values (3)15411677
 
4.4%
ValueCountFrequency (%)
T14477290
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII361932250
100.0%

Most frequent character per block

ValueCountFrequency (%)
091716826
25.3%
263490200
17.5%
:43431870
12.0%
134228870
 
9.5%
-28954580
 
8.0%
418498614
 
5.1%
817366875
 
4.8%
T14477290
 
4.0%
+14477290
 
4.0%
311026962
 
3.0%
Other values (4)24262873
 
6.7%

status
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
200
14477289 
302
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters43431870
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row200
2nd row200
3rd row200
4th row200
5th row200
ValueCountFrequency (%)
20014477289
> 99.9%
3021
 
< 0.1%
2021-05-08T23:52:29.975596image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
2021-05-08T23:52:30.039597image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
ValueCountFrequency (%)
20014477289
> 99.9%
3021
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
028954579
66.7%
214477290
33.3%
31
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number43431870
100.0%

Most frequent character per category

ValueCountFrequency (%)
028954579
66.7%
214477290
33.3%
31
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common43431870
100.0%

Most frequent character per script

ValueCountFrequency (%)
028954579
66.7%
214477290
33.3%
31
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII43431870
100.0%

Most frequent character per block

ValueCountFrequency (%)
028954579
66.7%
214477290
33.3%
31
 
< 0.1%

file
Categorical

HIGH CARDINALITY

Distinct913388
Distinct (%)6.3%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
/c1/2021/04/03_0/579989A52E63F61D92FE952F06717D89_20210403_1_1_582_mp4/084DBE6E316D033604F2363F78A3D821.m3u8
 
34560
/c1/2021/04/09_0/19076CF464FF1F138541D61832CACF27_20210409_1_1_1785_mp4/EBBBB4C4E9A9B37F510FEB87C2D1DFCB.m3u8
 
33996
/c1/2021/04/07_0/935DEFAB054FD50FDFE68A91CD6A7FA5_20210407_1_1_569_mp4/066EC1856110FFECFE939D599DF66E6B.m3u8
 
33122
/c1/2021/03/19_0/F3AC801ADCC688DF7036574E2415C6CA_20210319_1_1_624_mp4/0AD767483F2F54D104CE8C4F24083A2E.m3u8
 
32774
/c1/2021/04/09_0/022AABE72B34034DD6507A8D11C9EC97_20210409_2_1_1792_mp4/B106FBFC3E35D4ADD711D0E6615A40C8.m3u8
 
32518
Other values (913383)
14310320 

Length

Max length151
Median length116
Mean length113.8112637
Min length73

Characters and Unicode

Total characters1647678670
Distinct characters47
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique381855 ?
Unique (%)2.6%

Sample

1st row/c1/2021/02/20_0/481B858722405F7E39837605A91E8204_20210221_2_1_1156_mp4/6561DD1FC4E37E3D6A6B9643F36E2E30.m3u8
2nd row/c1/2021/03/20_0/F585736A7DD210F89DE3AEA196944728_20210321_2_1_1111_mp4/A4E09169781571E626E30EF155933EAE.m3u8
3rd row/c1/2020/06/09_1/B635E0C143F43265B4522F4F5C665A06_20200609_2_1_326_mp4/AF7209FFA8EEB51BB35FB6331CEFBEF1.m3u8
4th row/c1/2017/05/23_0/9682886A50AEC846687B165FA70C3748_20170523_1_1_585_mp4/528824180AF68D78A10545E9A395747E.m3u8
5th row/c1/internettv/2020/09/11_0/1B19375BF694C900E2EEE947169124FE_20200911_1_1_514_ts/419B68EEDBF0CE8CFC5428407E548206.m3u8
ValueCountFrequency (%)
/c1/2021/04/03_0/579989A52E63F61D92FE952F06717D89_20210403_1_1_582_mp4/084DBE6E316D033604F2363F78A3D821.m3u834560
 
0.2%
/c1/2021/04/09_0/19076CF464FF1F138541D61832CACF27_20210409_1_1_1785_mp4/EBBBB4C4E9A9B37F510FEB87C2D1DFCB.m3u833996
 
0.2%
/c1/2021/04/07_0/935DEFAB054FD50FDFE68A91CD6A7FA5_20210407_1_1_569_mp4/066EC1856110FFECFE939D599DF66E6B.m3u833122
 
0.2%
/c1/2021/03/19_0/F3AC801ADCC688DF7036574E2415C6CA_20210319_1_1_624_mp4/0AD767483F2F54D104CE8C4F24083A2E.m3u832774
 
0.2%
/c1/2021/04/09_0/022AABE72B34034DD6507A8D11C9EC97_20210409_2_1_1792_mp4/B106FBFC3E35D4ADD711D0E6615A40C8.m3u832518
 
0.2%
/c1/2021/04/09_0/3FD154763F0D65F4A33BFF30DCE640EB_20210409_2_1_657_mp4/B6AB695ADE44573E8CB56D4E7EBB49FE.m3u831647
 
0.2%
/c1/2021/03/26_0/7D766FA750D55E0671A058E281F47195_20210326_1_1_563_mp4/93BA6C18FFF3AAC34CE878814610D22A.m3u831315
 
0.2%
/c1/2021/04/03_0/53212C94F149E365BCC3AA62D7117241_20210403_1_1_215_mp4/164312FB15F9EEAC07CC2AA5FC2B0642.m3u830606
 
0.2%
/c1/2021/04/09_0/D402FCB9F83AA197AB792978554ED2B3_20210409_1_1_652_mp4/8DF5DD6D5490313BA318858C0539F42E.m3u829806
 
0.2%
/c1/2021/03/26_0/196731DD4A07C8752A7F53D902907A4C_20210326_1_1_207_mp4/D1D81FE2E665E246CDCC5A973CD80A05.m3u828184
 
0.2%
Other values (913378)14158762
97.8%
2021-05-08T23:52:32.109637image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
c1/2021/04/03_0/579989a52e63f61d92fe952f06717d89_20210403_1_1_582_mp4/084dbe6e316d033604f2363f78a3d821.m3u834560
 
0.2%
c1/2021/04/09_0/19076cf464ff1f138541d61832cacf27_20210409_1_1_1785_mp4/ebbbb4c4e9a9b37f510feb87c2d1dfcb.m3u833996
 
0.2%
c1/2021/04/07_0/935defab054fd50fdfe68a91cd6a7fa5_20210407_1_1_569_mp4/066ec1856110ffecfe939d599df66e6b.m3u833122
 
0.2%
c1/2021/03/19_0/f3ac801adcc688df7036574e2415c6ca_20210319_1_1_624_mp4/0ad767483f2f54d104ce8c4f24083a2e.m3u832774
 
0.2%
c1/2021/04/09_0/022aabe72b34034dd6507a8d11c9ec97_20210409_2_1_1792_mp4/b106fbfc3e35d4add711d0e6615a40c8.m3u832518
 
0.2%
c1/2021/04/09_0/3fd154763f0d65f4a33bff30dce640eb_20210409_2_1_657_mp4/b6ab695ade44573e8cb56d4e7ebb49fe.m3u831647
 
0.2%
c1/2021/03/26_0/7d766fa750d55e0671a058e281f47195_20210326_1_1_563_mp4/93ba6c18fff3aac34ce878814610d22a.m3u831315
 
0.2%
c1/2021/04/03_0/53212c94f149e365bcc3aa62d7117241_20210403_1_1_215_mp4/164312fb15f9eeac07cc2aa5fc2b0642.m3u830606
 
0.2%
c1/2021/04/09_0/d402fcb9f83aa197ab792978554ed2b3_20210409_1_1_652_mp4/8df5dd6d5490313ba318858c0539f42e.m3u829806
 
0.2%
c1/2021/03/26_0/196731dd4a07c8752a7f53d902907a4c_20210326_1_1_207_mp4/d1d81fe2e665e246cdcc5a973cd80a05.m3u828184
 
0.2%
Other values (913378)14158762
97.8%

Most occurring characters

ValueCountFrequency (%)
0151165477
 
9.2%
1148104386
 
9.0%
2134375689
 
8.2%
/94358958
 
5.7%
390883555
 
5.5%
_88022198
 
5.3%
882949822
 
5.0%
477899295
 
4.7%
970945647
 
4.3%
669007962
 
4.2%
Other values (37)639965681
38.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number958077097
58.1%
Uppercase Letter346898258
 
21.1%
Lowercase Letter145835429
 
8.9%
Other Punctuation108845687
 
6.6%
Connector Punctuation88022198
 
5.3%
Dash Punctuation1
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
t27656118
19.0%
m23060543
15.8%
u14738018
10.1%
c14729449
10.1%
n14509861
9.9%
e14490796
9.9%
p8572038
 
5.9%
i7253295
 
5.0%
v7251101
 
5.0%
r7246390
 
5.0%
Other values (16)6327820
 
4.3%
ValueCountFrequency (%)
0151165477
15.8%
1148104386
15.5%
2134375689
14.0%
390883555
9.5%
882949822
8.7%
477899295
8.1%
970945647
7.4%
669007962
7.2%
766538952
6.9%
566206312
6.9%
ValueCountFrequency (%)
E58050811
16.7%
A58012802
16.7%
D57989381
16.7%
F57960866
16.7%
C57675376
16.6%
B57209022
16.5%
ValueCountFrequency (%)
/94358958
86.7%
.14484369
 
13.3%
:2360
 
< 0.1%
ValueCountFrequency (%)
_88022198
100.0%
ValueCountFrequency (%)
-1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common1154944983
70.1%
Latin492733687
29.9%

Most frequent character per script

ValueCountFrequency (%)
E58050811
11.8%
A58012802
11.8%
D57989381
11.8%
F57960866
11.8%
C57675376
11.7%
B57209022
11.6%
t27656118
5.6%
m23060543
 
4.7%
u14738018
 
3.0%
c14729449
 
3.0%
Other values (22)65651301
13.3%
ValueCountFrequency (%)
0151165477
13.1%
1148104386
12.8%
2134375689
11.6%
/94358958
8.2%
390883555
7.9%
_88022198
7.6%
882949822
7.2%
477899295
6.7%
970945647
6.1%
669007962
6.0%
Other values (5)147231994
12.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII1647678670
100.0%

Most frequent character per block

ValueCountFrequency (%)
0151165477
 
9.2%
1148104386
 
9.0%
2134375689
 
8.2%
/94358958
 
5.7%
390883555
 
5.5%
_88022198
 
5.3%
882949822
 
5.0%
477899295
 
4.7%
970945647
 
4.3%
669007962
 
4.2%
Other values (37)639965681
38.8%

body_bytes_sent
Real number (ℝ≥0)

Distinct201
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean899.990504
Minimum800
Maximum1000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size110.5 MiB
2021-05-08T23:52:32.240014image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum800
5-th percentile810
Q1850
median900
Q3950
95-th percentile990
Maximum1000
Range200
Interquartile range (IQR)100

Descriptive statistics

Standard deviation58.01959347
Coefficient of variation (CV)0.06446689517
Kurtosis-1.199709334
Mean899.990504
Median Absolute Deviation (MAD)50
Skewness5.927451318 × 10-5
Sum1.302942352 × 1010
Variance3366.273227
MonotonicityNot monotonic
2021-05-08T23:52:32.352015image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
97072719
 
0.5%
98672700
 
0.5%
84472614
 
0.5%
95372594
 
0.5%
80772559
 
0.5%
88672553
 
0.5%
90472542
 
0.5%
86972540
 
0.5%
83472528
 
0.5%
90872503
 
0.5%
Other values (191)13751438
95.0%
ValueCountFrequency (%)
80072264
0.5%
80172410
0.5%
80271986
0.5%
80372419
0.5%
80472324
0.5%
ValueCountFrequency (%)
100071921
0.5%
99971893
0.5%
99872052
0.5%
99771944
0.5%
99671670
0.5%

request_time
Real number (ℝ≥0)

SKEWED
ZEROS

Distinct1302
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.001791007088
Minimum0
Maximum24.73
Zeros4551190
Zeros (%)31.4%
Negative0
Negative (%)0.0%
Memory size110.5 MiB
2021-05-08T23:52:32.472015image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.001
Q30.001
95-th percentile0.004
Maximum24.73
Range24.73
Interquartile range (IQR)0.001

Descriptive statistics

Standard deviation0.03192924597
Coefficient of variation (CV)17.82753747
Kurtosis178201.0368
Mean0.001791007088
Median Absolute Deviation (MAD)0
Skewness343.9438971
Sum25928.929
Variance0.001019476748
MonotonicityNot monotonic
2021-05-08T23:52:32.585024image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0017482735
51.7%
04551190
31.4%
0.0021003824
 
6.9%
0.003451721
 
3.1%
0.004306058
 
2.1%
0.005168414
 
1.2%
0.006126058
 
0.9%
0.00795521
 
0.7%
0.00889801
 
0.6%
0.00964977
 
0.4%
Other values (1292)136991
 
0.9%
ValueCountFrequency (%)
04551190
31.4%
0.0017482735
51.7%
0.0021003824
 
6.9%
0.003451721
 
3.1%
0.004306058
 
2.1%
ValueCountFrequency (%)
24.731
< 0.1%
22.6621
< 0.1%
22.4311
< 0.1%
22.2121
< 0.1%
21.4981
< 0.1%

uuid
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct14477290
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
29215db22a324aeb99b0f6a211182e12
 
1
2cded688385e475788d01659456b9dcc
 
1
602589bdafb244e783f148d049471494
 
1
63ccc4b5a7e54fa18e3ce110fe739f01
 
1
a76189cab42040ba9d7c210972d45576
 
1
Other values (14477285)
14477285 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters463273280
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique14477290 ?
Unique (%)100.0%

Sample

1st rowcc8af1795c1f41d5928a812894582677
2nd rowe08080787bfb45dcbb06b2a2794bbd19
3rd row16ef9189edb047da9eb2c80f7c699989
4th row2ae94ad529634ba092012ee451854ba4
5th row7e1e28044456459fab1d3aa865670398
ValueCountFrequency (%)
29215db22a324aeb99b0f6a211182e121
 
< 0.1%
2cded688385e475788d01659456b9dcc1
 
< 0.1%
602589bdafb244e783f148d0494714941
 
< 0.1%
63ccc4b5a7e54fa18e3ce110fe739f011
 
< 0.1%
a76189cab42040ba9d7c210972d455761
 
< 0.1%
49ca7433f6a340d4ae530194b023ebe31
 
< 0.1%
88509ef2b45740ddae15316048773c511
 
< 0.1%
1a5e325917ce4e9abc5f234572c0d74b1
 
< 0.1%
8717447e1c2f422e9ff889feb6eee1bf1
 
< 0.1%
1c6698171afa4b27ae30a10ad312e3681
 
< 0.1%
Other values (14477280)14477280
> 99.9%
2021-05-08T23:53:14.469734image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
29215db22a324aeb99b0f6a211182e121
 
< 0.1%
2cded688385e475788d01659456b9dcc1
 
< 0.1%
602589bdafb244e783f148d0494714941
 
< 0.1%
63ccc4b5a7e54fa18e3ce110fe739f011
 
< 0.1%
a76189cab42040ba9d7c210972d455761
 
< 0.1%
49ca7433f6a340d4ae530194b023ebe31
 
< 0.1%
88509ef2b45740ddae15316048773c511
 
< 0.1%
1a5e325917ce4e9abc5f234572c0d74b1
 
< 0.1%
8717447e1c2f422e9ff889feb6eee1bf1
 
< 0.1%
1c6698171afa4b27ae30a10ad312e3681
 
< 0.1%
Other values (14477280)14477280
> 99.9%

Most occurring characters

ValueCountFrequency (%)
441617507
 
9.0%
b30780809
 
6.6%
a30768376
 
6.6%
830757980
 
6.6%
930757268
 
6.6%
327151276
 
5.9%
227150266
 
5.9%
c27149337
 
5.9%
627148653
 
5.9%
027147850
 
5.9%
Other values (6)162843958
35.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number293145823
63.3%
Lowercase Letter170127457
36.7%

Most frequent character per category

ValueCountFrequency (%)
441617507
14.2%
830757980
10.5%
930757268
10.5%
327151276
9.3%
227150266
9.3%
627148653
9.3%
027147850
9.3%
527142384
9.3%
127138524
9.3%
727134115
9.3%
ValueCountFrequency (%)
b30780809
18.1%
a30768376
18.1%
c27149337
16.0%
d27146720
16.0%
f27143187
16.0%
e27139028
16.0%

Most occurring scripts

ValueCountFrequency (%)
Common293145823
63.3%
Latin170127457
36.7%

Most frequent character per script

ValueCountFrequency (%)
441617507
14.2%
830757980
10.5%
930757268
10.5%
327151276
9.3%
227150266
9.3%
627148653
9.3%
027147850
9.3%
527142384
9.3%
127138524
9.3%
727134115
9.3%
ValueCountFrequency (%)
b30780809
18.1%
a30768376
18.1%
c27149337
16.0%
d27146720
16.0%
f27143187
16.0%
e27139028
16.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII463273280
100.0%

Most frequent character per block

ValueCountFrequency (%)
441617507
 
9.0%
b30780809
 
6.6%
a30768376
 
6.6%
830757980
 
6.6%
930757268
 
6.6%
327151276
 
5.9%
227150266
 
5.9%
c27149337
 
5.9%
627148653
 
5.9%
027147850
 
5.9%
Other values (6)162843958
35.2%

http_referer
Categorical

HIGH CARDINALITY

Distinct111821
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
-
13432309 
https://www.mgtv.com/
 
129825
https://w.mgtv.com/
 
11201
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq
 
5250
https://www.mgtv.com/b/349986/11579395.html
 
4517
Other values (111816)
 
894188

Length

Max length637
Median length1
Mean length4.304199405
Min length1

Characters and Unicode

Total characters62313143
Distinct characters73
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique53939 ?
Unique (%)0.4%

Sample

1st row-
2nd row-
3rd row-
4th rowhttps://www.mgtv.com/b/166040/3557859.html
5th row-
ValueCountFrequency (%)
-13432309
92.8%
https://www.mgtv.com/129825
 
0.9%
https://w.mgtv.com/11201
 
0.1%
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq5250
 
< 0.1%
https://www.mgtv.com/b/349986/11579395.html4517
 
< 0.1%
https://www.mgtv.com/b/349986/11404545.html4338
 
< 0.1%
https://www.mgtv.com/b/361838/11387905.html?fpa=se&lastp=so_result2585
 
< 0.1%
https://www.mgtv.com/b/364015/11388708.html2479
 
< 0.1%
https://www.mgtv.com/b/341204/11442179.html2204
 
< 0.1%
https://www.mgtv.com/b/344620/11494133.html?cxid=90f0zbamf2193
 
< 0.1%
Other values (111811)880389
 
6.1%
2021-05-08T23:53:14.936565image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
13432309
92.8%
https://www.mgtv.com129996
 
0.9%
https://w.mgtv.com11201
 
0.1%
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq5250
 
< 0.1%
https://www.mgtv.com/b/349986/11579395.html4517
 
< 0.1%
https://www.mgtv.com/b/349986/11404545.html4338
 
< 0.1%
https://www.mgtv.com/b/361838/11387905.html?fpa=se&lastp=so_result2585
 
< 0.1%
https://www.mgtv.com/b/364015/11388708.html2479
 
< 0.1%
https://www.mgtv.com/b/341204/11442179.html2204
 
< 0.1%
https://www.mgtv.com/b/344620/11494133.html?cxid=90f0zbamf2193
 
< 0.1%
Other values (111399)880218
 
6.1%

Most occurring characters

ValueCountFrequency (%)
-13450932
21.6%
/4825245
 
7.7%
t4271377
 
6.9%
m3179968
 
5.1%
w3104529
 
5.0%
.2995385
 
4.8%
12049596
 
3.3%
h2027148
 
3.3%
31972966
 
3.2%
41494966
 
2.4%
Other values (63)22941031
36.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter24555414
39.4%
Decimal Number13701265
22.0%
Dash Punctuation13450932
21.6%
Other Punctuation9699984
 
15.6%
Math Symbol485062
 
0.8%
Uppercase Letter330705
 
0.5%
Connector Punctuation89781
 
0.1%

Most frequent character per category

ValueCountFrequency (%)
t4271377
17.4%
m3179968
13.0%
w3104529
12.6%
h2027148
8.3%
c1388513
 
5.7%
p1310128
 
5.3%
s1303110
 
5.3%
o1225565
 
5.0%
g1095633
 
4.5%
l1085588
 
4.4%
Other values (16)4563855
18.6%
ValueCountFrequency (%)
F105907
32.0%
A74225
22.4%
E62188
18.8%
D33231
 
10.0%
B24009
 
7.3%
C14474
 
4.4%
P5842
 
1.8%
S3528
 
1.1%
I723
 
0.2%
K516
 
0.2%
Other values (16)6062
 
1.8%
ValueCountFrequency (%)
12049596
15.0%
31972966
14.4%
41494966
10.9%
01489462
10.9%
51248232
9.1%
91228925
9.0%
21192620
8.7%
61069630
7.8%
81029338
7.5%
7925530
6.8%
ValueCountFrequency (%)
/4825245
49.7%
.2995385
30.9%
:1029656
 
10.6%
%347324
 
3.6%
?311592
 
3.2%
&190778
 
2.0%
,4
 
< 0.1%
ValueCountFrequency (%)
=484808
99.9%
~254
 
0.1%
ValueCountFrequency (%)
-13450932
100.0%
ValueCountFrequency (%)
_89781
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common37427024
60.1%
Latin24886119
39.9%

Most frequent character per script

ValueCountFrequency (%)
t4271377
17.2%
m3179968
12.8%
w3104529
12.5%
h2027148
8.1%
c1388513
 
5.6%
p1310128
 
5.3%
s1303110
 
5.2%
o1225565
 
4.9%
g1095633
 
4.4%
l1085588
 
4.4%
Other values (42)4894560
19.7%
ValueCountFrequency (%)
-13450932
35.9%
/4825245
 
12.9%
.2995385
 
8.0%
12049596
 
5.5%
31972966
 
5.3%
41494966
 
4.0%
01489462
 
4.0%
51248232
 
3.3%
91228925
 
3.3%
21192620
 
3.2%
Other values (11)5478695
14.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII62313143
100.0%

Most frequent character per block

ValueCountFrequency (%)
-13450932
21.6%
/4825245
 
7.7%
t4271377
 
6.9%
m3179968
 
5.1%
w3104529
 
5.0%
.2995385
 
4.8%
12049596
 
3.3%
h2027148
 
3.3%
31972966
 
3.2%
41494966
 
2.4%
Other values (63)22941031
36.8%

http_user_agent
Categorical

HIGH CARDINALITY

Distinct118100
Distinct (%)0.8%
Missing194
Missing (%)< 0.1%
Memory size110.5 MiB
Go-http-client/1.1
7329791 
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1220.1 Darwin/20.3.0
 
206535
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1220.1 Darwin/20.3.0
 
164734
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36
 
130771
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1128.0.1 Darwin/19.6.0
 
105254
Other values (118095)
6540011 

Length

Max length924
Median length18
Mean length51.18498938
Min length1

Characters and Unicode

Total characters741010005
Distinct characters93
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique63658 ?
Unique (%)0.4%

Sample

1st rowImgoTV-ipad-AppStore/6.3.8.20123119 CFNetwork/1128.0.1 Darwin/19.6.0
2nd rowDalvik/2.1.0 (Linux; U; Android 9; ART-AL00x Build/HUAWEIART-AL00x) imgotv-aphone-6.8.5
3rd rowDalvik/2.1.0 (Linux; U; Android 10; PCNM00 Build/QKQ1.190915.002) imgotv-aphone-6.7.4
4th rowMozilla/5.0 (iPad; CPU OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 VideoArticle/9.4.9 JsSdk/2.0 NetType/WIFI (Video 5.4.9 12.4.8) newiPad
5th rowGo-http-client/1.1
ValueCountFrequency (%)
Go-http-client/1.17329791
50.6%
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1220.1 Darwin/20.3.0206535
 
1.4%
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1220.1 Darwin/20.3.0164734
 
1.1%
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36130771
 
0.9%
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1128.0.1 Darwin/19.6.0105254
 
0.7%
ImgoTV-ipad-AppStore/6.3.10.21031716 CFNetwork/1220.1 Darwin/20.3.092837
 
0.6%
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1128.0.1 Darwin/19.6.082329
 
0.6%
Dalvik/2.1.0 (Linux; U; Android 9.0.0; MI 10 MIUI/11.11.22) imgotv-aphone-6.6.476350
 
0.5%
MGTV-iPhone-appstore/6.8.3.2103112210 CFNetwork/1220.1 Darwin/20.3.072172
 
0.5%
Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.3671090
 
0.5%
Other values (118090)6145233
42.4%
2021-05-08T23:53:15.392750image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
go-http-client/1.17329791
 
12.3%
linux4141260
 
7.0%
android4140140
 
7.0%
u4140020
 
7.0%
dalvik/2.1.04127931
 
6.9%
102730332
 
4.6%
imgotv-aphone-6.8.61879812
 
3.2%
imgotv-aphone-6.8.51384776
 
2.3%
mozilla/5.01031857
 
1.7%
like1008465
 
1.7%
Other values (60429)27512443
46.3%

Most occurring characters

ValueCountFrequency (%)
.49588225
 
6.7%
145510336
 
6.1%
44979176
 
6.1%
i37442493
 
5.1%
035864450
 
4.8%
t31425502
 
4.2%
-30769848
 
4.2%
o30392022
 
4.1%
/25897024
 
3.5%
n24457402
 
3.3%
Other values (83)384683527
51.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter299310758
40.4%
Decimal Number151921203
20.5%
Uppercase Letter111006540
 
15.0%
Other Punctuation90464014
 
12.2%
Space Separator44979176
 
6.1%
Dash Punctuation30769848
 
4.2%
Open Punctuation6163379
 
0.8%
Close Punctuation6163374
 
0.8%
Connector Punctuation220579
 
< 0.1%
Math Symbol10426
 
< 0.1%
Other values (2)708
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
A14130935
 
12.7%
G10205727
 
9.2%
L8895839
 
8.0%
D6737384
 
6.1%
U6427456
 
5.8%
M6331020
 
5.7%
N5474776
 
4.9%
W5349833
 
4.8%
T4688047
 
4.2%
B4446872
 
4.0%
Other values (16)38318651
34.5%
ValueCountFrequency (%)
i37442493
12.5%
t31425502
10.5%
o30392022
10.2%
n24457402
 
8.2%
e22465539
 
7.5%
l19563369
 
6.5%
p18051474
 
6.0%
a15719356
 
5.3%
h13851430
 
4.6%
d13829168
 
4.6%
Other values (16)72113003
24.1%
ValueCountFrequency (%)
.49588225
54.8%
/25897024
28.6%
;13544653
 
15.0%
,976647
 
1.1%
%397897
 
0.4%
:56445
 
0.1%
@1444
 
< 0.1%
*705
 
< 0.1%
#702
 
< 0.1%
&169
 
< 0.1%
Other values (3)103
 
< 0.1%
ValueCountFrequency (%)
145510336
30.0%
035864450
23.6%
215001756
 
9.9%
614431503
 
9.5%
39411913
 
6.2%
88979007
 
5.9%
56872851
 
4.5%
76184586
 
4.1%
95542884
 
3.6%
44121917
 
2.7%
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%
ValueCountFrequency (%)
+9683
92.9%
~696
 
6.7%
|24
 
0.2%
=23
 
0.2%
ValueCountFrequency (%)
(6163373
> 99.9%
[6
 
< 0.1%
ValueCountFrequency (%)
)6163368
> 99.9%
]6
 
< 0.1%
ValueCountFrequency (%)
^702
99.9%
`1
 
0.1%
ValueCountFrequency (%)
-30769848
100.0%
ValueCountFrequency (%)
44979176
100.0%
ValueCountFrequency (%)
_220579
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin410317298
55.4%
Common330692702
44.6%
Han5
 
< 0.1%

Most frequent character per script

ValueCountFrequency (%)
i37442493
 
9.1%
t31425502
 
7.7%
o30392022
 
7.4%
n24457402
 
6.0%
e22465539
 
5.5%
l19563369
 
4.8%
p18051474
 
4.4%
a15719356
 
3.8%
A14130935
 
3.4%
h13851430
 
3.4%
Other values (42)182817776
44.6%
ValueCountFrequency (%)
.49588225
15.0%
145510336
13.8%
44979176
13.6%
035864450
10.8%
-30769848
9.3%
/25897024
7.8%
215001756
 
4.5%
614431503
 
4.4%
;13544653
 
4.1%
39411913
 
2.8%
Other values (26)45693818
13.8%
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII741010000
> 99.9%
CJK5
 
< 0.1%

Most frequent character per block

ValueCountFrequency (%)
.49588225
 
6.7%
145510336
 
6.1%
44979176
 
6.1%
i37442493
 
5.1%
035864450
 
4.8%
t31425502
 
4.2%
-30769848
 
4.2%
o30392022
 
4.1%
/25897024
 
3.5%
n24457402
 
3.3%
Other values (78)384683522
51.9%
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

http_x_forwarded_for
Categorical

HIGH CARDINALITY

Distinct2071062
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
-
2018472 
b815d5425eac36951c5dd43a60690df6
 
234073
4ce875fe568a297345bc8677a5da5abb
 
234053
bb34f10e2b27ced77ad5384e7ab95032
 
233930
527155957fd152e37702ff76f3193cfb
 
233859
Other values (2071057)
11522903 

Length

Max length131
Median length32
Mean length41.57135293
Min length1

Characters and Unicode

Total characters601840532
Distinct characters18
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1066072 ?
Unique (%)7.4%

Sample

1st row6c455e37ea1f3f43443ecbe46bcdb4bb
2nd row-
3rd row-
4th rowaaa477e9b59a19d1a1a6f5fc0d869bfe
5th rowbb34f10e2b27ced77ad5384e7ab95032
ValueCountFrequency (%)
-2018472
 
13.9%
b815d5425eac36951c5dd43a60690df6234073
 
1.6%
4ce875fe568a297345bc8677a5da5abb234053
 
1.6%
bb34f10e2b27ced77ad5384e7ab95032233930
 
1.6%
527155957fd152e37702ff76f3193cfb233859
 
1.6%
68cb6218c13547be5924970a6c5ce299233549
 
1.6%
cf402f90900932518e83d47db7540b3b,3f0165ec0a29c8a954c806264acb843748387
 
0.3%
cf402f90900932518e83d47db7540b3b,b6955f515645ab1f4192ae0ddb78d6e248189
 
0.3%
3b774c4e91ade00ef45833c4316fd8b1,e4c41df8cd856981cef9a66a810be62b48142
 
0.3%
3b774c4e91ade00ef45833c4316fd8b1,460417f487042281a5035b8d6843888647603
 
0.3%
Other values (2071052)11097033
76.7%
2021-05-08T23:53:20.431171image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2018472
 
13.9%
b815d5425eac36951c5dd43a60690df6234073
 
1.6%
4ce875fe568a297345bc8677a5da5abb234053
 
1.6%
bb34f10e2b27ced77ad5384e7ab95032233930
 
1.6%
527155957fd152e37702ff76f3193cfb233859
 
1.6%
68cb6218c13547be5924970a6c5ce299233549
 
1.6%
cf402f90900932518e83d47db7540b3b,3f0165ec0a29c8a954c806264acb843748387
 
0.3%
cf402f90900932518e83d47db7540b3b,b6955f515645ab1f4192ae0ddb78d6e248189
 
0.3%
3b774c4e91ade00ef45833c4316fd8b1,e4c41df8cd856981cef9a66a810be62b48142
 
0.3%
3b774c4e91ade00ef45833c4316fd8b1,460417f487042281a5035b8d6843888647603
 
0.3%
Other values (2071052)11097033
76.7%

Most occurring characters

ValueCountFrequency (%)
343624839
 
7.2%
642275205
 
7.0%
940008871
 
6.6%
a38507373
 
6.4%
037578756
 
6.2%
437438131
 
6.2%
837044111
 
6.2%
536739683
 
6.1%
d36735026
 
6.1%
136310628
 
6.0%
Other values (8)215577909
35.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number381063390
63.3%
Lowercase Letter212663522
35.3%
Other Punctuation6095148
 
1.0%
Dash Punctuation2018472
 
0.3%

Most frequent character per category

ValueCountFrequency (%)
343624839
11.4%
642275205
11.1%
940008871
10.5%
037578756
9.9%
437438131
9.8%
837044111
9.7%
536739683
9.6%
136310628
9.5%
735580164
9.3%
234463002
9.0%
ValueCountFrequency (%)
a38507373
18.1%
d36735026
17.3%
b35332896
16.6%
e35301330
16.6%
c34441077
16.2%
f32345820
15.2%
ValueCountFrequency (%)
-2018472
100.0%
ValueCountFrequency (%)
,6095148
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common389177010
64.7%
Latin212663522
35.3%

Most frequent character per script

ValueCountFrequency (%)
343624839
11.2%
642275205
10.9%
940008871
10.3%
037578756
9.7%
437438131
9.6%
837044111
9.5%
536739683
9.4%
136310628
9.3%
735580164
9.1%
234463002
8.9%
Other values (2)8113620
 
2.1%
ValueCountFrequency (%)
a38507373
18.1%
d36735026
17.3%
b35332896
16.6%
e35301330
16.6%
c34441077
16.2%
f32345820
15.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII601840532
100.0%

Most frequent character per block

ValueCountFrequency (%)
343624839
 
7.2%
642275205
 
7.0%
940008871
 
6.6%
a38507373
 
6.4%
037578756
 
6.2%
437438131
 
6.2%
837044111
 
6.2%
536739683
 
6.1%
d36735026
 
6.1%
136310628
 
6.0%
Other values (8)215577909
35.8%

pno
Real number (ℝ≥0)

Distinct11
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean440606.5055
Minimum1010
Maximum1131010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size110.5 MiB
2021-05-08T23:53:20.531172image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum1010
5-th percentile1010
Q11141
median1141
Q31101020
95-th percentile1131010
Maximum1131010
Range1130000
Interquartile range (IQR)1099879

Descriptive statistics

Standard deviation540886.0453
Coefficient of variation (CV)1.227594324
Kurtosis-1.82412063
Mean440606.5055
Median Absolute Deviation (MAD)111
Skewness0.4184902382
Sum6.378788156 × 1012
Variance2.92557714 × 1011
MonotonicityNot monotonic
2021-05-08T23:53:20.611707image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
11416004441
41.5%
11010102027897
 
14.0%
11011411325350
 
9.2%
10101135175
 
7.8%
10301023812
 
7.1%
11010201010191
 
7.0%
1131010980775
 
6.8%
1101021413704
 
2.9%
1120305156
 
2.1%
1021225931
 
1.6%
ValueCountFrequency (%)
10101135175
7.8%
1021225931
 
1.6%
10301023812
7.1%
1120305156
 
2.1%
112124858
 
0.2%
ValueCountFrequency (%)
1131010980775
6.8%
11011411325350
9.2%
1101021413704
 
2.9%
11010201010191
7.0%
11010102027897
14.0%

Id
Categorical

HIGH CARDINALITY

Distinct68806
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
-
14408028 
1617449162208
 
3
1618060943325
 
3
1617625226068
 
3
1617974649600
 
3
Other values (68801)
 
69250

Length

Max length13
Median length1
Mean length1.057408603
Min length1

Characters and Unicode

Total characters15308411
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique68352 ?
Unique (%)0.5%

Sample

1st row-
2nd row-
3rd row-
4th row-
5th row-
ValueCountFrequency (%)
-14408028
99.5%
16174491622083
 
< 0.1%
16180609433253
 
< 0.1%
16176252260683
 
< 0.1%
16179746496003
 
< 0.1%
16180609480272
 
< 0.1%
16163870316572
 
< 0.1%
16177980454612
 
< 0.1%
16176256039402
 
< 0.1%
16179747006732
 
< 0.1%
Other values (68796)69240
 
0.5%
2021-05-08T23:53:20.907677image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
14408028
99.5%
16179746496003
 
< 0.1%
16180609433253
 
< 0.1%
16176252260683
 
< 0.1%
16174491622083
 
< 0.1%
16176252404112
 
< 0.1%
16176253440482
 
< 0.1%
16176252872712
 
< 0.1%
16176255699992
 
< 0.1%
16172761326282
 
< 0.1%
Other values (68796)69240
 
0.5%

Most occurring characters

ValueCountFrequency (%)
-14408028
94.1%
1188296
 
1.2%
6155337
 
1.0%
7108655
 
0.7%
977977
 
0.5%
471128
 
0.5%
870029
 
0.5%
060371
 
0.4%
259245
 
0.4%
557761
 
0.4%

Most occurring categories

ValueCountFrequency (%)
Dash Punctuation14408028
94.1%
Decimal Number900383
 
5.9%

Most frequent character per category

ValueCountFrequency (%)
1188296
20.9%
6155337
17.3%
7108655
12.1%
977977
8.7%
471128
 
7.9%
870029
 
7.8%
060371
 
6.7%
259245
 
6.6%
557761
 
6.4%
351584
 
5.7%
ValueCountFrequency (%)
-14408028
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common15308411
100.0%

Most frequent character per script

ValueCountFrequency (%)
-14408028
94.1%
1188296
 
1.2%
6155337
 
1.0%
7108655
 
0.7%
977977
 
0.5%
471128
 
0.5%
870029
 
0.5%
060371
 
0.4%
259245
 
0.4%
557761
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII15308411
100.0%

Most frequent character per block

ValueCountFrequency (%)
-14408028
94.1%
1188296
 
1.2%
6155337
 
1.0%
7108655
 
0.7%
977977
 
0.5%
471128
 
0.5%
870029
 
0.5%
060371
 
0.4%
259245
 
0.4%
557761
 
0.4%

auth_ret
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size110.5 MiB
0
11781340 
1
2695950 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters14477290
Distinct characters2
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row1
3rd row0
4th row0
5th row0
ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%
2021-05-08T23:53:21.103106image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram of lengths of the category
2021-05-08T23:53:21.169101image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%

Most occurring characters

ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number14477290
100.0%

Most frequent character per category

ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%

Most occurring scripts

ValueCountFrequency (%)
Common14477290
100.0%

Most frequent character per script

ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII14477290
100.0%

Most frequent character per block

ValueCountFrequency (%)
011781340
81.4%
12695950
 
18.6%

Interactions

2021-05-08T23:50:48.409827image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
2021-05-08T23:50:52.074723image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
2021-05-08T23:50:55.795828image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
2021-05-08T23:50:59.244577image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
2021-05-08T23:51:03.051671image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
2021-05-08T23:51:06.501115image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Correlations

2021-05-08T23:53:21.226101image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2021-05-08T23:53:21.353101image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2021-05-08T23:53:21.479101image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2021-05-08T23:53:21.607107image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.
2021-05-08T23:53:21.717381image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

2021-05-08T23:51:09.842642image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
A simple visualization of nullity by column.
2021-05-08T23:51:20.138620image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2021-05-08T23:51:39.743537image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

remote_addrtime_iso8601statusfilebody_bytes_sentrequest_timeuuidhttp_refererhttp_user_agenthttp_x_forwarded_forpnoIdauth_ret
06c455e37ea1f3f43443ecbe46bcdb4bb2021-03-22T12:20:00+08:00200/c1/2021/02/20_0/481B858722405F7E39837605A91E8204_20210221_2_1_1156_mp4/6561DD1FC4E37E3D6A6B9643F36E2E30.m3u89160.003cc8af1795c1f41d5928a812894582677-ImgoTV-ipad-AppStore/6.3.8.20123119 CFNetwork/1128.0.1 Darwin/19.6.06c455e37ea1f3f43443ecbe46bcdb4bb1101021-0
164eaa6e58e5bd71d54dd7565481a2f1d2021-03-22T12:20:00+08:00200/c1/2021/03/20_0/F585736A7DD210F89DE3AEA196944728_20210321_2_1_1111_mp4/A4E09169781571E626E30EF155933EAE.m3u89660.002e08080787bfb45dcbb06b2a2794bbd19-Dalvik/2.1.0 (Linux; U; Android 9; ART-AL00x Build/HUAWEIART-AL00x) imgotv-aphone-6.8.5-1101010-1
24d4c7b25b890132ee432bebab39409662021-03-22T12:20:00+08:00200/c1/2020/06/09_1/B635E0C143F43265B4522F4F5C665A06_20200609_2_1_326_mp4/AF7209FFA8EEB51BB35FB6331CEFBEF1.m3u89080.00016ef9189edb047da9eb2c80f7c699989-Dalvik/2.1.0 (Linux; U; Android 10; PCNM00 Build/QKQ1.190915.002) imgotv-aphone-6.7.4-1131010-0
3da177836163927897f26c718d1daf85f2021-03-22T12:20:00+08:00200/c1/2017/05/23_0/9682886A50AEC846687B165FA70C3748_20170523_1_1_585_mp4/528824180AF68D78A10545E9A395747E.m3u88970.0012ae94ad529634ba092012ee451854ba4https://www.mgtv.com/b/166040/3557859.htmlMozilla/5.0 (iPad; CPU OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 VideoArticle/9.4.9 JsSdk/2.0 NetType/WIFI (Video 5.4.9 12.4.8) newiPadaaa477e9b59a19d1a1a6f5fc0d869bfe1121-0
4affef57aacffb8aa6e911659e55f54b22021-03-22T12:20:00+08:00200/c1/internettv/2020/09/11_0/1B19375BF694C900E2EEE947169124FE_20200911_1_1_514_ts/419B68EEDBF0CE8CFC5428407E548206.m3u88720.0017e1e28044456459fab1d3aa865670398-Go-http-client/1.1bb34f10e2b27ced77ad5384e7ab950321141-0
550f0c33ea2cc1396dabf8d6b87e299242021-03-22T12:20:00+08:00200/c1/ugc/2020/08/28_0/1EFC7CE6D5D2438003EB4831A5D16C7A_20200828_1_1_831_mp4/1EFC7CE6D5D2438003EB4831A5D16C7A.m3u88870.000574c8128f2a34c06a9b5020891644be3-Dalvik/2.1.0 (Linux; U; Android 9; S1W Build/PPR1.180610.011) imgotv-aphone-6.8.150f0c33ea2cc1396dabf8d6b87e299241010-0
65e65cf248d09fc5a85bdfaa91730f9412021-03-22T12:20:00+08:00200/c1/2018/09/28_0/EE56CA0944B101EE772A351C93DE11C5_20180928_1_1_416_mp4/984DE33F32FA849A923BDBA14DE53A52.m3u89440.001616a1c94b0f34300829e3eaf2e6b566a-Dalvik/2.1.0 (Linux; U; Android 9; vivo X21A Build/PKQ1.180819.001) imgotv-aphone-6.8.5-1010-0
79969257ba05151554902e600f906778a2021-03-22T12:20:00+08:00200/c1/2021/03/19_0/12C74013D7B1B022D98098D94C4CFD8B_20210319_1_1_2370_mp4/E8B1E6A711C14241C9C9B7C2B3863543.m3u89680.000200f4728a3c94f729f217fc976090bc8https://www.mgtv.com/b/354045/11396546.htmlMozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36af4d14e020570b7ec39b5b886835f6b71030-0
8ba502af9b23d4866f52ea9ff345d21062021-03-22T12:20:00+08:00200/c1/2021/02/06_1/88DD62A8610401A54BB4FDB2C66D372B_20210208_2_1_1086_mp4/6402ABFEF811CA8E20E5C85A4E6B079D.m3u88380.0016ce4e6747d6f4d0aa7ab44916d69d59c-ImgoTV-ipad-AppStore/6.3.9.21030517 CFNetwork/1209 Darwin/20.2.0317dd352917e837ae0c46deb80f923aa1101021-0
99a866b922b4564c0b9a2f03e98d1e3ae2021-03-22T12:20:00+08:00200/c1/2018/09/26_0/E42F9772724C3627722F408D923E264A_20180926_1_1_1440_mp4/5BD38307F55EFDFBBB55A58AD67025C7.m3u89740.001ea7fbea1647b4b818cf7dac0fe21b8cb-Dalvik/2.1.0 (Linux; U; Android 9; V1945A Build/PKQ1.190626.001) imgotv-aphone-6.8.49a866b922b4564c0b9a2f03e98d1e3ae1010-0

Last rows

remote_addrtime_iso8601statusfilebody_bytes_sentrequest_timeuuidhttp_refererhttp_user_agenthttp_x_forwarded_forpnoIdauth_ret
14477280401a4dda7eb323f1434eeae2eae17d612021-04-10T21:29:59+08:00200/c1/internettv/2018/06/21_0/AD8957707DA5683B1F2E0A7545E74954_20180621_1_1_1164_ts/85D65E7883C48527EB3ED9FFC64EF8EA.m3u88650.000eeb5c9f0c96e45d4ae5373816f7a022a-Go-http-client/1.1d3053ecc7317dcbcd6373d9788b931da,116074ddb263e0fc3e9f13111bebd97a1141-0
144772814fb80f13f377fb753e581fd2fe9c6d992021-04-10T21:29:59+08:00200/c1/internettv/2020/06/04_0/E9FDF73B61A592BD0E09527593A35F47_20200604_1_1_787_ts/0880D5669FAFF5B66F75EDA464F8423F.m3u88340.001ba2c578f0d22477bb60ee2bb4e955c9f-Go-http-client/1.10a32aa93d13a16dd4628728a3fe75621,3f0165ec0a29c8a954c806264acb84371141-1
144772825dd72d98c765879856a2e6ebece85d1c2021-04-10T21:29:59+08:00200/c1/2020/07/15_0/D51880A6B878C7DAECC6AB65B82EB0ED_20200715_1_1_351_mp4/95B160D5822221B1047232B2DDFA12D7.m3u89710.001af5647a651a24e79b10853c1e528db6f-MGTV-iPhone-appstore/6.1.3.1812061610 CFNetwork/711.5.6 Darwin/14.0.0cfb602127c2672d0aa2c67a7df7aea711120-0
14477283460f209ba797187919ab9f764b03c23f2021-04-10T21:29:59+08:00200/c1/2021/02/18_0/62F8D181FBF8B763577B797ACE54F884_20210218_1_1_374_mp4/41BD712B5FA578A095A52864F46BE947.m3u88800.0019fa4c64eaf25482e9ac906a3733df645-Dalvik/2.1.0 (Linux; U; Android 10; PCHM10 Build/QKQ1.200209.002) imgotv-aphone-6.8.6-1131010-1
14477284d9fdd48b48000e794261f7010476740c2021-04-10T21:29:59+08:00200/c1/internettv/2021/03/25_0/930C81826B2CC2DA77693C098F2A37B8_20210330_2_1_763_mp4/3E7E7D30DA997B52D7FFEFD23C0F6D28.m3u88380.009fe09e01920774e42ac8a7cf1089f33ae-Go-http-client/1.1dfbd8ae63d4045452993f636a366cb66,116074ddb263e0fc3e9f13111bebd97a1101141-0
14477285e3aa71aa8088614e03134bc9b60785042021-04-10T21:30:00+08:00200/c1/2021/04/06_0/CDDD7E69F07E11B5A381A2A75121E6D3_20210406_2_1_277_mp4/B9E223654C295F4735CF7EFB346A136E.m3u89480.0077cab750a992a4c62ac8a43ab0a785695-Dalvik/2.1.0 (Linux; U; Android 10; TAS-AN00 Build/HUAWEITAS-AN00) imgotv-aphone-6.8.6-1101010-0
14477286d90a5c809b4100d326ef487c3e2470372021-04-10T21:30:00+08:00200/c1/internettv/2020/07/12_0/15736F5F87C7F833FA00E2CA467754F3_20200712_1_1_955_ts/A312A6D77B78CB6DB43B26A294744828.m3u88440.00027a793b76f7046c6879ee62652dd9eb9-Go-http-client/1.1d3053ecc7317dcbcd6373d9788b931da,cdfd154e4e70778fa29d32e35477402c1141-0
14477287b8f960e721df22b38b257f4a40611a252021-04-10T21:30:00+08:00200/c1/internettv/2021/04/06_0/8B25921195482080D73A871DC6ED33A6_20210406_1_1_983_ts/BD6D409CBE5BBD7F0C4142197B8DB704.m3u88950.00151ac87c8290b4fa387a352ae83e68a6b-Go-http-client/1.13b774c4e91ade00ef45833c4316fd8b1,b6955f515645ab1f4192ae0ddb78d6e21141-0
14477288623af85c05ac5f4a4c93e4c5cd3fc9172021-04-10T21:30:00+08:00200/c1/2021/03/04_1/830CCB31E60A733A6680EB009E0A6AAF_20210304_2_1_631_mp4/B02432801C9BA64AA574F9D866F93357.m3u89440.0021c101c94dcc44bd0b876a7c1edd2ac26-Dalvik/2.1.0 (Linux; U; Android 10; JEF-AN20 Build/HUAWEIJEF-AN20) imgotv-aphone-6.8.6-1131010-0
144772894870445dcac98155d9f9cf10c0e348b42021-04-10T21:30:00+08:00200/c1/2021/04/10_0/4F7A8D20648453D2028557367E7A7DC2_20210410_2_1_1167_mp4/C069C2ADC8B8EA0224E55AFF0212560C.m3u88430.0014a60d2dae8a543f2b7c9463db4e88bf3-Dalvik/2.1.0 (Linux; U; Android 10; WKG-AN00 Build/HUAWEIWKG-AN00) imgotv-aphone-6.8.6-1101010-0